Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MySQL
1) Aggregate Functions
2) Backup Load
3) Command Mysql
4) Cursor
5) Data Type
6) Database
7) Date Time
8) Engine
9) Event
10) Flow Control
11) Fulltext Search
12) Function
13) Geometric
14) Insert Delete Update
15) Internationalization
16) Join
17) Key
18) Math
19) Procedure Function
20) Regular Expression
21) Select Clause
22) String
23) Table Index
24) Transaction
25) Trigger
26) User Permission
27) View
28) Where Clause
29) XML

Backup Load
1) Add null value to dumped file
2) Adding an ESCAPED BY subclause
3) Backup database
4) Backup records into txt file
5) Backup table records into txt file
6) Change the terminator for fields
7) Change the ternimator for lines
8) Create dump file
9) Dump data into a text file
10) Dump data into text file and change the default terminators
11) Dump the database into sql file
12) Escape sign
13) Exporting Data Out of a Table
14) Exporting Data to a Dump File
15) Exporting from MySQL
16) Exporting from MySQL indicating , terminator
17) Exporting from MySQL indicating the terminator
18) If you are using a Linux system, replace the rn in the LINES TERMINATED BY syntax command with just n
19) IGNORE is often useful with files generated by external sources
20) IGNORE numeric_value lines
21) Importing CSV Files
22) LINES subclauses
23) Line starting string
24) Load backup file into new table
25) Load data in txt file into database
26) Load text data into table
27) Naming Datafiles Under Windows
28) Set division with
29) Set ENCLOSED terminator
30) Set OPTIONALLY ENCLOSED
31) Skipping Datafile Lines
32) Specifying the Datafile Format
33) Specifying the Location of Files on the Client Host
34) Terminates each line with end
35) The syntax for a command to use a comma-separated text file, saved in a Windows format
36) To export the passwd table in CSV format with CRLF-terminated lines, use this statement
37) To put the rows on separate lines, you must modify the TERMINATED BY subclause
38) To specify a file format explicitly, use a FIELDS clause to describe the characteristics of fields within a line
39) Using mysql in Batch Mode